/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80016
 Source Host           : localhost:3306
 Source Schema         : platform

 Target Server Type    : MySQL
 Target Server Version : 80016
 File Encoding         : 65001

 Date: 26/04/2020 17:55:52
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
create table sys_config
(
    id                 varchar(32)                                                  not null primary key,
    code               enum ('platform')                  default 'platform'        not null comment '编码',
    role_inheritance   enum ('General', 'Limited')       default 'Limited'         not null comment '角色继承 Limited 受限继承 General 一般继承',
    separation_of_duty enum ('SSD', 'DSD')     default 'SSD'      not null comment '职责分离 SSD 静态 DSD 动态',
    permission_grain   enum ('Menu', 'Operation', 'Data') default 'Data'            not null comment '权限粒度 功能菜单权限 Menu 功能操作权限 Operation 数据字段权限 Data',
    flag               varchar(10)                        default 'enable'         null comment '标记',
    create_by          varchar(50)                                                  null,
    create_date        datetime                           default CURRENT_TIMESTAMP null,
    update_by          varchar(50)                                                  null,
    update_date        datetime                           default CURRENT_TIMESTAMP null,
    constraint sys_config_pk
        unique (code)
)
    comment '平台配置表';

-- ----------------------------
-- Table structure for sys_config_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_config_detail`;
CREATE TABLE `sys_config_detail` (
  `config_detail_id` varchar(32) NOT NULL,
  `detail_code` varchar(10) DEFAULT NULL COMMENT '编码',
  `detail_name` varchar(50) DEFAULT NULL COMMENT '配置名称',
  `detail_value` varchar(50) DEFAULT NULL COMMENT '配置数据',
  `group_id` varchar(32) DEFAULT NULL COMMENT '配置组id',
  `parent_id` varchar(32) DEFAULT NULL COMMENT '父id',
  `parent_ids` varchar(200) DEFAULT NULL COMMENT '父id集合',
  `info` varchar(100) DEFAULT NULL COMMENT '描述',
  `is_sys` char(1) DEFAULT '0' COMMENT '是否为系统配置 0否 1是，系统配置为不可修改',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`config_detail_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统配置明细表';

-- ----------------------------
-- Table structure for sys_config_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_config_group`;
CREATE TABLE `sys_config_group` (
  `config_group_id` varchar(32) NOT NULL,
  `group_code` varchar(10) DEFAULT NULL COMMENT '编码',
  `group_name` varchar(50) DEFAULT NULL COMMENT '配置组名称',
  `info` varchar(100) DEFAULT NULL COMMENT '描述',
  `is_sys` char(1) DEFAULT '0' COMMENT '是否为系统配置 0否 1是，系统配置为不可修改',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`config_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统配置表组';

-- ----------------------------
-- Table structure for sys_element
-- ----------------------------
DROP TABLE IF EXISTS `sys_element`;
CREATE TABLE `sys_element` (
  `element_id` varchar(50) NOT NULL,
  `element_code` varchar(10) DEFAULT NULL COMMENT '元素编码',
  `element_name` varchar(50) DEFAULT NULL COMMENT '元素名称',
  `info` varchar(100) DEFAULT NULL COMMENT '描述',
  `edit_time` datetime DEFAULT NULL COMMENT '编辑时间',
  `editor` varchar(50) DEFAULT NULL COMMENT '编辑人',
  `detail` varchar(500) DEFAULT NULL COMMENT '内容',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`element_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='页面元素表';

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file` (
  `file_id` varchar(50) NOT NULL,
  `file_name` varchar(50) NOT NULL COMMENT '文件名称',
  `file_path` varchar(200) NOT NULL COMMENT '文件路径',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='文件表';

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menu_id` varchar(50) NOT NULL,
  `code` varchar(50) DEFAULT NULL COMMENT '菜单编码',
  `sys_code` varchar(50) NOT NULL COMMENT '所属的系统编码',
  `menu_name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `menu_url` varchar(200) DEFAULT NULL COMMENT '菜单路径',
  `parent_id` varchar(50) DEFAULT NULL COMMENT '上级',
  `parent_ids` varchar(500) DEFAULT NULL COMMENT '层级',
  `order_num` int(11) DEFAULT NULL COMMENT '排序',
  `menu_icon` varchar(50) NOT NULL DEFAULT '' COMMENT '图标',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`menu_id`),
  UNIQUE KEY `sys_menu_code_uindex` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('1', 'flatform', 'system', '平台', '', '0', '0', 1, 'Hui-iconfont-home', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('10', 'product', 'system', '产品管理', '', '1', '1', 3, 'Hui-iconfont-goods', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('11', 'review', 'system', '评论管理', '', '1', '1', 4, 'Hui-iconfont-comment', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('1111', 'flatform2', 'system', '平台2', '', '0', '0', 5, 'Hui-iconfont-home', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('12', 'mebmanage', 'system', '会员管理', '', '1', '1', 5, 'Hui-iconfont-user2', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('13', 'admin', 'system', '管理员管理', '', '1', '1', 6, 'Hui-iconfont-root', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('14', 'syscount', 'system', '系统统计', '', '1', '1', 7, 'Hui-iconfont-tongji', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('15', 'sysmanage', 'system', '系统管理', '', '1', '1', 8, 'Hui-iconfont-system', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('16', '16', 'system', '资讯管理', 'article/list', '8', '1,8', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('17', '17', 'system', '图片管理', 'picture/list', '9', '1,9', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('18', '18', 'system', '品牌管理', 'product/brand', '10', '1,10', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('19', '19', 'system', '分类管理', 'product/category', '10', '1,10', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('2', 'menufirst', 'menu', '一级菜单', '', '0', '0', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('20', '20', 'system', '产品管理', 'product/list', '10', '1,10', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('21', '21', 'system', '评论列表', 'http://h-ui.duoshuo.comadmin/', '11', '1,11', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('22', '22', 'system', '意见反馈', 'feedback/list', '11', '1,11', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('23', '23', 'system', '会员列表', 'member/list', '12', '1,12', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('24', '24', 'system', '删除的会员', 'member/del', '12', '1,12', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('25', '25', 'system', '等级管理', 'member/level', '12', '1,12', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('26', '26', 'system', '积分管理', 'member/scoreoperation', '12', '1,12', 4, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('27', '27', 'system', '浏览记录', 'memberRecord/browse', '12', '1,12', 5, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('28', '28', 'system', '下载记录', 'memberRecord/download', '12', '1,12', 6, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('29', '29', 'system', '分享记录', 'memberRecord/share', '12', '1,12', 7, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('3', 'finance', 'finance', '财务', '', '0', '0', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('30', '30', 'system', '角色管理', 'admin/role', '13', '1,13', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('31', '31', 'system', '权限管理', 'admin/permission', '13', '1,13', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('32', '32', 'system', '管理员列表', 'admin/list', '13', '1,13', 4, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('33', '33', 'system', '折线图', 'charts/1', '14', '1,14', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('34', '34', 'system', '时间轴折线图', 'charts/2', '14', '1,14', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('35', '35', 'system', '区域图', 'charts/3', '14', '1,14', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('36', '36', 'system', '柱状图', 'charts/4', '14', '1,14', 4, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('37', '37', 'system', '饼状图', 'charts/5', '14', '1,14', 5, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('38', '38', 'system', '3D柱状图', 'charts/6', '14', '1,14', 6, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('39', '39', 'system', '3D饼状图', 'charts/7', '14', '1,14', 7, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('4', 'weixin', 'weixin', '微信', '', '0', '0', 4, 'Hui-iconfont-weixin', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('40', '40', 'system', '系统设置', 'system/base', '15', '1,15', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('41', '41', 'system', '栏目管理', 'system/category', '15', '1,15', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('42', '42', 'system', '数据字典', 'system/data', '15', '1,15', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('43', '43', 'system', '屏蔽词', 'system/shielding', '15', '1,15', 4, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('44', '44', 'system', '系统日志', 'system/log', '15', '1,15', 5, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('45', '45', 'system', '代码生成', 'system/codeing', '15', '1,15', 6, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('5', '5', 'menu', '二级页面1', 'member/list', '2', '2', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('50', '50', 'menu', '二级页面2', 'member/list', '2', '2', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('51', '51', 'menu', '二级菜单', '', '2', '2', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('52', '52', 'menu', '三级页面1', 'member/list', '51', '2,51', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('53', '53', 'menu', '三级页面2', 'member/list', '51', '2,51', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('54', '54', 'menu', '三级菜单', '', '51', '2,51', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('55', '55', 'menu', '四级页面1', 'member/list', '54', '2,51,54', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('56', '56', 'menu', '四级菜单', '', '54', '2,51,54', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('57', '57', 'menu', '四级页面3', 'member/list', '54', '2,51,54', 3, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('58', '58', 'menu', '五级页面1', 'member/list', '56', '2,51,54,56', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('59', '59', 'menu', '五级页面2', 'member/list', '56', '2,51,54,56', 2, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('6', '6', 'finance', '三级导航', '', '3', '3', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('60', '60', 'system', '角色组列表', 'admin/rolegroup', '13', '1,13', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('61', '61', 'system', '菜单列表', 'admin/menu', '13', '1,13', 5, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('7', '7', 'weixin', '四级导航', '', '4', '4', 1, '', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('8', 'mesmanage', 'system', '资讯管理', '', '1', '1', 1, 'Hui-iconfont-news', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
INSERT INTO `sys_menu` VALUES ('9', 'pic', 'system', '图片管理', '', '1', '1', 2, 'Hui-iconfont-tuku', 'enable', 'system', '2020-02-24 21:14:58', 'system', '2020-02-24 21:14:58');
COMMIT;

-- ----------------------------
-- Table structure for sys_module
-- ----------------------------
DROP TABLE IF EXISTS `sys_module`;
CREATE TABLE `sys_module` (
  `module_id` varchar(32) NOT NULL,
  `module_name` varchar(50) NOT NULL COMMENT '模块名称',
  `module_code` varchar(50) NOT NULL COMMENT '模块编码',
  `info` varchar(100) DEFAULT NULL COMMENT '简述',
  `parent_id` varchar(32) DEFAULT NULL,
  `parent_ids` varchar(200) DEFAULT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(32) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`module_id`),
  UNIQUE KEY `sys_module_code` (`module_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统模块表';

-- ----------------------------
-- Table structure for sys_module_operation
-- ----------------------------
DROP TABLE IF EXISTS `sys_module_operation`;
CREATE TABLE `sys_module_operation` (
  `id` varchar(32) NOT NULL,
  `module_id` varchar(32) NOT NULL,
  `operation_id` varchar(32) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(32) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模块操作关联表';

-- ----------------------------
-- Table structure for sys_module_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_module_resource`;
CREATE TABLE `sys_module_resource` (
  `id` varchar(50) NOT NULL,
  `module_id` varchar(50) NOT NULL,
  `resource_id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模块资源关联表';

-- ----------------------------
-- Table structure for sys_operation
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation`;
CREATE TABLE `sys_operation` (
  `operation_id` varchar(50) NOT NULL,
  `operation_name` varchar(50) DEFAULT NULL COMMENT '操作名称',
  `operation_code` varchar(50) NOT NULL COMMENT '功能操作编码',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`operation_id`),
  UNIQUE KEY `sys_operation_code` (`operation_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='功能操作表';

-- ----------------------------
-- Table structure for sys_privilege
-- ----------------------------
DROP TABLE IF EXISTS `sys_privilege`;
CREATE TABLE `sys_privilege` (
  `privilege_id` varchar(50) NOT NULL,
  `privilege_name` varchar(100) DEFAULT NULL COMMENT '权限名称',
  `privilege_type` varchar(50) NOT NULL COMMENT '权限类型',
  `info` varchar(50) DEFAULT NULL COMMENT '描述',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  PRIMARY KEY (`privilege_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='权限表';

-- ----------------------------
-- Records of sys_privilege
-- ----------------------------
BEGIN;
INSERT INTO `sys_privilege` VALUES ('98548394863099904', '添加', 'menu', NULL, 'enable', 'system', '2020-03-22 23:14:16', 'system', '2020-03-22 23:14:16');
INSERT INTO `sys_privilege` VALUES ('98548394863099905', '删除', 'menu', NULL, 'enable', 'system', '2020-03-22 23:14:16', 'system', '2020-03-22 23:14:16');
INSERT INTO `sys_privilege` VALUES ('98548394863099906', '编辑', 'menu', NULL, 'enable', 'system', '2020-03-22 23:14:16', 'system', '2020-03-22 23:14:16');
INSERT INTO `sys_privilege` VALUES ('98548394863099907', '查看', 'menu', NULL, 'enable', 'system', '2020-03-22 23:14:16', 'system', '2020-03-22 23:14:16');
COMMIT;

-- ----------------------------
-- Table structure for sys_privilege_element
-- ----------------------------
DROP TABLE IF EXISTS `sys_privilege_element`;
CREATE TABLE `sys_privilege_element` (
  `id` varchar(50) NOT NULL,
  `privilege_id` varchar(50) NOT NULL,
  `element_id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='权限页面元素关联表';

-- ----------------------------
-- Table structure for sys_privilege_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_privilege_file`;
CREATE TABLE `sys_privilege_file` (
  `id` varchar(50) NOT NULL,
  `privilege_id` varchar(50) NOT NULL,
  `file_id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='权限文件关联表';

-- ----------------------------
-- Table structure for sys_privilege_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_privilege_menu`;
CREATE TABLE `sys_privilege_menu` (
  `id` varchar(50) NOT NULL,
  `privilege_id` varchar(50) NOT NULL,
  `menu_id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='权限菜单关联表';

-- ----------------------------
-- Table structure for sys_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_resource`;
CREATE TABLE `sys_resource` (
  `resource_id` varchar(50) NOT NULL,
  `resource_name` varchar(50) DEFAULT NULL COMMENT '模块资源名称',
  `resource_code` varchar(50) NOT NULL COMMENT '模块资源编码',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`resource_id`),
  UNIQUE KEY `sys_resource_code` (`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='模块资源表';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `role_id` varchar(50) NOT NULL,
  `role_name` varchar(50) NOT NULL COMMENT '角色名称',
  `max_users` int(11) DEFAULT '999' COMMENT '最大数量限制 基数约束',
  `info` varchar(100) DEFAULT NULL COMMENT '角色描述说明',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('98674753371373575', '平台管理员角色', 1, '统一平台管理员角色', 'enable', 'system', '2020-04-19 12:59:07', 'system', '2020-04-19 12:59:11');
INSERT INTO `sys_role` VALUES ('98674753371373576', '系统管理员角色', 1, '平台管理员角色', 'enable', 'system', '2020-04-19 12:59:07', 'system', '2020-04-19 12:59:11');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_exclude
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_exclude`;
CREATE TABLE `sys_role_exclude` (
  `id` varchar(50) NOT NULL,
  `role_id` varchar(50) NOT NULL,
  `union_id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色互斥表';

-- ----------------------------
-- Records of sys_role_exclude
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_exclude` VALUES ('98674753371373577', '98674753371373575', '98674753371373579', 'enable', 'system', '2020-04-19 17:20:42', 'system', '2020-04-19 17:20:42');
INSERT INTO `sys_role_exclude` VALUES ('98674753371373578', 'any', '98674753371373579', 'enable', 'system', '2020-04-19 17:20:42', 'system', '2020-04-19 17:20:42');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_group`;
CREATE TABLE `sys_role_group` (
  `role_group_id` varchar(50) NOT NULL,
  `role_group_name` varchar(50) NOT NULL COMMENT '角色组名称',
  `parent_id` varchar(50) DEFAULT NULL COMMENT '角色组父id',
  `info` varchar(100) DEFAULT NULL COMMENT '描述',
  `parent_ids` varchar(500) DEFAULT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`role_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统角色组';

-- ----------------------------
-- Records of sys_role_group
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_group` VALUES ('1253970700474101762', '测试使用的', '1', '1', '1', 'enable', 'user', '2020-04-25 16:54:47', 'user', '2020-04-25 16:54:47');
INSERT INTO `sys_role_group` VALUES ('98674753371373570', '微信管理员组', '98674753371373571', '微信平台管理员最高权限', 'top,98674753371373571', 'enable', 'user', '2020-02-22 23:50:42', 'user', '2020-02-22 23:50:42');
INSERT INTO `sys_role_group` VALUES ('98674753371373571', '平台管理员组', 'top', '最高权限管理者', 'top', 'enable', 'user', '2020-01-27 00:26:25', 'user', '2020-01-27 00:26:25');
INSERT INTO `sys_role_group` VALUES ('98674753371373572', 'App管理员组', '98674753371373571', 'App端', 'top,98674753371373571', 'enable', 'user', '2020-01-27 15:51:27', 'user', '2020-01-27 15:51:27');
INSERT INTO `sys_role_group` VALUES ('98674753371373573', '商城系统管理员组', '98674753371373571', '商城系统最高管理权限', 'top,98674753371373571', 'enable', 'user', '2020-01-27 00:33:04', 'user', '2020-01-27 00:33:04');
INSERT INTO `sys_role_group` VALUES ('98674753371373574', '系统管理员组', '98674753371373571', '微信平台管理员最高权限', 'top,98674753371373571', 'enable', 'user', '2020-02-22 23:50:42', 'user', '2020-02-22 23:50:42');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_group_operation
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_group_operation`;
CREATE TABLE `sys_role_group_operation` (
  `id` varchar(32) NOT NULL,
  `role_group_id` varchar(32) NOT NULL,
  `operation_id` varchar(32) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(32) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色组操作关联表';

-- ----------------------------
-- Table structure for sys_role_group_privilege
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_group_privilege`;
CREATE TABLE `sys_role_group_privilege` (
  `id` varchar(32) NOT NULL,
  `role_group_id` varchar(32) NOT NULL,
  `privilege_id` varchar(32) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(32) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色组权限关联表';

-- ----------------------------
-- Table structure for sys_role_group_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_group_resource`;
CREATE TABLE `sys_role_group_resource` (
  `id` varchar(32) NOT NULL,
  `role_group_id` varchar(32) NOT NULL,
  `resource_id` varchar(32) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(32) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色组资源关联表';

-- ----------------------------
-- Table structure for sys_role_group_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_group_role`;
CREATE TABLE `sys_role_group_role` (
  `id` varchar(32) NOT NULL,
  `role_group_id` varchar(32) NOT NULL,
  `role_id` varchar(32) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(32) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(32) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色组角色关联表';

-- ----------------------------
-- Table structure for sys_role_operation
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_operation`;
CREATE TABLE `sys_role_operation` (
  `id` varchar(50) NOT NULL,
  `role_id` varchar(50) NOT NULL,
  `operation_id` varchar(50) NOT NULL,
  `apply_sql` varchar(100) DEFAULT NULL COMMENT '补充的sql',
  `info` varchar(100) DEFAULT NULL COMMENT '描述',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色操作关联表';

-- ----------------------------
-- Table structure for sys_role_privilege
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_privilege`;
CREATE TABLE `sys_role_privilege` (
  `id` varchar(50) NOT NULL,
  `role_id` varchar(50) NOT NULL,
  `privilege_id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色权限关联表';

-- ----------------------------
-- Table structure for sys_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_resource`;
CREATE TABLE `sys_role_resource` (
  `id` varchar(50) NOT NULL,
  `role_id` varchar(50) NOT NULL,
  `resource_id` varchar(50) NOT NULL,
  `apply_sql` varchar(100) DEFAULT NULL COMMENT '补充的sql',
  `info` varchar(100) DEFAULT NULL COMMENT '描述',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='角色资源关联表';

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `user_id` varchar(50) NOT NULL COMMENT 'id',
  `user_name` varchar(50) NOT NULL COMMENT '用户名',
  `login_name` varchar(50) NOT NULL COMMENT '登录名称',
  `password` varchar(50) NOT NULL COMMENT '登录密码',
  `phone` varchar(13) NOT NULL COMMENT '手机号码',
  `email` varchar(50) NOT NULL COMMENT '邮箱',
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `sys_user_loginname` (`login_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('98674753371373568', '统一平台管理员', 'superadmin', '1', '13589748388', '610232785@qq.com', 'enable', 'system', '2020-04-19 12:38:04', 'system', '2020-04-19 12:38:09');
INSERT INTO `sys_user` VALUES ('98674753371373574', '管理员', 'admin', '1', '13589748388', '610232785@qq.com', 'enable', 'system', '2020-04-19 12:38:04', 'system', '2020-04-19 12:38:09');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_group
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_group`;
CREATE TABLE `sys_user_group` (
  `user_group_id` varchar(50) NOT NULL,
  `user_group_name` varchar(50) NOT NULL,
  `info` varchar(100) DEFAULT NULL COMMENT '描述',
  `parent_id` varchar(50) DEFAULT NULL,
  `parent_ids` varchar(500) DEFAULT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='系统用户组';

-- ----------------------------
-- Records of sys_user_group
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_group` VALUES ('98674753371373581', '平台管理员组', '平台管理员组', 'top', 'top', 'enable', 'system', '2020-04-19 17:55:21', 'system', '2020-04-19 17:55:27');
INSERT INTO `sys_user_group` VALUES ('98674753371373582', '管理员组', '管理员组', '98674753371373581', 'top,98674753371373581', 'enable', 'system', '2020-04-19 17:55:21', 'system', '2020-04-19 17:55:27');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_group_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_group_role`;
CREATE TABLE `sys_user_group_role` (
  `user_group_id` varchar(50) NOT NULL,
  `role_id` varchar(50) NOT NULL,
  `id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户组角色关联表';

-- ----------------------------
-- Records of sys_user_group_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_group_role` VALUES ('98674753371373582', '98674753371373576', '1253967676049457153', NULL, 'user', '2020-04-25 16:42:46', 'user', '2020-04-25 16:42:46');
INSERT INTO `sys_user_group_role` VALUES ('98674753371373582', '98674753371373576', '1253968596888047617', NULL, 'user', '2020-04-25 16:46:26', 'user', '2020-04-25 16:46:26');
INSERT INTO `sys_user_group_role` VALUES ('98674753371373582', '98674753371373576', '1253972588456062978', 'enable', 'user', '2020-04-25 17:02:17', 'user', '2020-04-25 17:02:17');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_group_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_group_user`;
CREATE TABLE `sys_user_group_user` (
  `id` varchar(50) NOT NULL,
  `user_group_id` varchar(50) NOT NULL,
  `user_id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户组用户关联表';

-- ----------------------------
-- Records of sys_user_group_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_group_user` VALUES ('98674753371373567', '98674753371373582', '98674753371373574', 'enable', 'system', '2020-04-19 12:55:30', 'system', '2020-04-19 12:55:34');
INSERT INTO `sys_user_group_user` VALUES ('98674753371373569', '98674753371373581', '98674753371373568', 'enable', 'system', '2020-04-19 12:55:30', 'system', '2020-04-19 12:55:34');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` varchar(50) NOT NULL,
  `user_id` varchar(50) NOT NULL,
  `role_id` varchar(50) NOT NULL,
  `flag` varchar(10) DEFAULT NULL COMMENT '标记',
  `create_by` varchar(50) DEFAULT NULL,
  `create_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `update_by` varchar(50) DEFAULT NULL,
  `update_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='用户角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1253967679090327553', '98674753371373574', '98674753371373576', NULL, 'user', '2020-04-25 16:42:47', 'user', '2020-04-25 16:42:47');
INSERT INTO `sys_user_role` VALUES ('1253972591153000449', '98674753371373574', '98674753371373576', 'enable', 'user', '2020-04-25 17:02:18', 'user', '2020-04-25 17:02:18');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
